Model balance sheet and cash flow

Use the Balance Sheet and Cash Flow calculator to model how your forecasts affect your balance sheet.

To set up the calculator:

1. Configure planning settings specific to the calculator:

   • Enable the calculator to update automatically in response to changes in related plan files.

     NOTE: The trigger must be set to Yes if you intend to use the calculator.

   • Select to include or exclude income in the Balance Sheet (default is exclude). Select Include if net income is not already included in the Balance Sheet net assets.

2. Create a balance sheet group (BalanceSheet Grp) to designate which RFGroups to include in your balance sheet model.

3. Configure balance sheet assumptions.

To use the Balance Sheet and Cash Flow calculator:

1. In the RF Admin task pane under Other Calculators section, double-click Balance Sheet and Cash Flow.

2. In the Refresh Variables dialog, do the following:

   1. For Select an RF Balance Sheet Group, click Choose Value, select the balance sheet group, and then click OK.

      NOTE: The RF balance sheet group determines which RFGroups are included in the calculator. You can have as many balance sheets groups as necessary.

   2. For Select a Scenario, click Choose Value, select a scenario, and then click OK.

3. In the Forecast tab of the Balance Sheet and Cash Flow calculator, work your way across and down the sheet, selecting calculation methods and adding or adjusting values as needed for the various sections and time periods.

4. On the Main ribbon tab, click Save.

5. In the Financial Statements sheet, view the modeled results.

6. (Optional) Return to the Financial sheet and make adjustments as needed to refine forecast results. At any time, you can select Refresh Data on the Main ribbon tab to select other scenarios or balance sheet groups.